# 实现数据库的连接白
# 使用 pymysql实现数据库的操作
import pymysql
# 通过pymysql创建一个连接对象

dbc=pymysql.Connect(user='root',password="123456",host="172.16.0.254",port=3306,database="crm9")

runner=dbc.cursor()
sql="SELECT * from 72crm_oa_log where create_user_id =(SELECT user_id from 72crm_admin_user where username='17513230010');"
s=runner.execute(sql)

print(s)
print(runner.fetchone())
print(runner.fetchall())


